package com.jsh.erp.datasource.entities;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class ExcelXSDDExport {

    @Excel(name = "发货单号", width = 25)
    private String number;

    @Excel(name = "单据日期", exportFormat = "yyyy/MM/dd", width = 20)
    private Date operTime;

    @Excel(name = "客户名称", width = 35)
    private String supplier;

    @Excel(name = "地区分类（省）", width = 20)
    private String province;

    @Excel(name = "市", width = 15)
    private String city;

    @Excel(name = "业务员", width = 15)
    private String personName;

    @Excel(name = "存货编号", width = 15)
    private String barCode;

    @Excel(name = "存货名称", width = 25)
    private String materialName;

    @Excel(name = "规格型号", width = 15)
    private String standard;

    @Excel(name = "发货数量", numFormat = "#.###", width = 20)
    private BigDecimal operNumber;

    @Excel(name = "发货价税合计", numFormat = "#.##", width = 20)
    private String allPrice;

    @Excel(name = "核定运输", width = 15)
    private String traffic;

    @Excel(name = "核定运价", width = 15)
    private String cost;

    @Excel(name = "包装要求", width = 15)
    private String packageType;

    @Excel(name = "备注说明", width = 15)
    private String remark;
}
